package com.kg.module.jtnc.rghs.excels;

import java.util.LinkedHashMap;

/**
 * Excel使用常量 - 人工核算表
 *
 * @author xxx
 * @date 2024-11-02
 */
public class KrRghsExcelConstant {
    /**
     * 导出所需的字段信息
     */
    public static LinkedHashMap<String, String> EXPORT_EXCEL_COLUMN = new LinkedHashMap<>();
    /**
     * 导入所需字段信息
     */
    public static LinkedHashMap<String, String> IMPORT_EXCEL_COLUMN = new LinkedHashMap<>();
    /**
     * 导入必填字段信息
     */
    public static LinkedHashMap<String, String> IMPORT_REQUIRED_COLUMN = new LinkedHashMap<>();

    static {
        // 初始化导出字段
        EXPORT_EXCEL_COLUMN.put("dkglId", "地块id");
        EXPORT_EXCEL_COLUMN.put("dkmc", "地块名称");
        EXPORT_EXCEL_COLUMN.put("nhId", "农户id");
        EXPORT_EXCEL_COLUMN.put("nhxm", "农户姓名");
        EXPORT_EXCEL_COLUMN.put("ygrq", "用工日期");
        EXPORT_EXCEL_COLUMN.put("ygrs", "用工人数");
        EXPORT_EXCEL_COLUMN.put("ygsc", "用工时长");
        EXPORT_EXCEL_COLUMN.put("ygfy", "用工费用");
        EXPORT_EXCEL_COLUMN.put("ygnr", "用工内容");
        EXPORT_EXCEL_COLUMN.put("createTime", "添加时间");
        EXPORT_EXCEL_COLUMN.put("updateTime", "更新时间");
        EXPORT_EXCEL_COLUMN.put("jsyId", "技术员id");
        EXPORT_EXCEL_COLUMN.put("jsyxm", "技术员姓名");
        EXPORT_EXCEL_COLUMN.put("state", "核算状态（0：待确认，1:已确认，2:已拒绝）");
        // 初始化导入字段
        IMPORT_EXCEL_COLUMN.put("地块id", "dkglId");
        IMPORT_EXCEL_COLUMN.put("地块名称", "dkmc");
        IMPORT_EXCEL_COLUMN.put("农户id", "nhId");
        IMPORT_EXCEL_COLUMN.put("农户姓名", "nhxm");
        IMPORT_EXCEL_COLUMN.put("用工日期", "ygrq");
        IMPORT_EXCEL_COLUMN.put("用工人数", "ygrs");
        IMPORT_EXCEL_COLUMN.put("用工时长", "ygsc");
        IMPORT_EXCEL_COLUMN.put("用工费用", "ygfy");
        IMPORT_EXCEL_COLUMN.put("用工内容", "ygnr");
        IMPORT_EXCEL_COLUMN.put("技术员id", "jsyId");
        IMPORT_EXCEL_COLUMN.put("技术员姓名", "jsyxm");
        IMPORT_EXCEL_COLUMN.put("核算状态（0：待确认，1:已确认，2:已拒绝）", "state");
        // 初始化导入必填字段
    }

}